UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nhqRlai54rqHQwsdUqFvfvliRk5HB8dUiwpiZIXR9Bs='
WHERE
key_id = 'bcfc15c588f7ff246874fe637633f2c898b8bed63ffb7eadaeb62912998b8f26'
AND (
token = 'nhqRlai54rqHQwsdUqFvfvliRk5HB8dUiwpiZIXR9Bs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)