UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ts7OHRPABZh5ZcmxAvNDiviZ4mtoTDlac98Vo1OiGGg='
WHERE
key_id = '5b24edc2b6766299ff1f0eb83e075f4fced24bb4cd943d5c0a3e4362589de100'
AND (
token = 'Ts7OHRPABZh5ZcmxAvNDiviZ4mtoTDlac98Vo1OiGGg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)