UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ez7+pB1EMJyBKZQoWfsuKAEt0SNBc5nRhETAhKBJRWU='
WHERE
key_id = '78c2180cd29c7c8a575da7ac987d91ca17dbd48ac100ca14d9056fab64610147'
AND (
token = 'ez7+pB1EMJyBKZQoWfsuKAEt0SNBc5nRhETAhKBJRWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)