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