UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZJ6Fs2AGEtwSAxB9Maq4fW29AMB3FAcrfycKtaxsdWs='
WHERE
key_id = '0e9f9bf2fbbd63fc265d557ad1e34889477ba8bd95959a0bd9d4dfd2720eb7e2'
AND (
token = 'ZJ6Fs2AGEtwSAxB9Maq4fW29AMB3FAcrfycKtaxsdWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)