UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Znk3a/gW8qDOIohJhigOod+fiA9CGa3Hag65bZ7l8mM='
WHERE
key_id = '3f2797436ce8fd868899a79d3df50789f6ea18ed1f326158e8400801edf74709'
AND (
token = 'Znk3a/gW8qDOIohJhigOod+fiA9CGa3Hag65bZ7l8mM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)