UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H0A7k66y7h3ET+bXUXhQFZACyACQmTMJJWyW7XiUFKU='
WHERE
key_id = '9cba8125ea8ed4ffcd6b5308164ff5333c1a31b3078eb0b6b04908730b69f2cd'
AND (
token = 'H0A7k66y7h3ET+bXUXhQFZACyACQmTMJJWyW7XiUFKU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)