UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OiPDhXF35mtIzjmT+/Sly7JGGIVtAbhbps3Nsvckt+Q='
WHERE
key_id = 'b971096fcaa5db4fefad237182b96f0a2f6598ad373880446699ca228be3a2c8'
AND (
token = 'OiPDhXF35mtIzjmT+/Sly7JGGIVtAbhbps3Nsvckt+Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)