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