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