UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'guKZE9lv8qNVlSMWGkyDRetFA2yfV7g1YosyUqkNTPQ='
WHERE
key_id = '685408ee752d0172240fa99243c748ef980f624d01b26a97ae6f605e080de625'
AND (
token = 'guKZE9lv8qNVlSMWGkyDRetFA2yfV7g1YosyUqkNTPQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)