UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+1ZrBqG1S8pqnq1Wb0VsxiptLzMm9Qcmx6xNjS46wQw='
WHERE
key_id = '1ccba91072821243791b3cc66033c9eb6fdad8f859eb0107945f13b984dff241'
AND (
token = '+1ZrBqG1S8pqnq1Wb0VsxiptLzMm9Qcmx6xNjS46wQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)