UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rQgCY3fWATxUHCLH4OIR9EeaOeJ9EBRlUmSSjB8NYds='
WHERE
key_id = 'ec0d0d0d33673a147c97031be4af0ec8618fa6d5dc6bafca4139f7c79e8d1a27'
AND (
token = 'rQgCY3fWATxUHCLH4OIR9EeaOeJ9EBRlUmSSjB8NYds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)