UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pqOrdPYjPMOgGigKZZYS6AkRmIElqRSeLMKmaDb/FqA='
WHERE
key_id = 'c370c7e3442954fc11959d6ce708ac0e24a0ba9a73f9af91506f53222bc2a1a7'
AND (
token = 'pqOrdPYjPMOgGigKZZYS6AkRmIElqRSeLMKmaDb/FqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)