UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H9dkbX6/CrUhbU0DZVUU+NHWNagEtOoZhn68udVe4lc='
WHERE
key_id = 'b5f88771f5ddd3c2fe39cf86fcbe5bc71665f7e602ad7cf8472bdbb1a9a8e200'
AND (
token = 'H9dkbX6/CrUhbU0DZVUU+NHWNagEtOoZhn68udVe4lc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)