UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CrhliL/p9Xdkx/teJuhQoJNQ4MyVR7CmqMrG2rbtdcM='
WHERE
key_id = 'c0a9f891ad39bd2a50f90cd9b8f9aa0df761d42520cfe3e6bf3fbee7b80fcab6'
AND (
token = 'CrhliL/p9Xdkx/teJuhQoJNQ4MyVR7CmqMrG2rbtdcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)