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