UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HRFOy01MyB/qkkcl1XOpmBOQ4/HzQdImyR1guyzH+1I='
WHERE
key_id = 'e278bf213dadb2ce5b0123368039da3112997a4467a1d1025df96c845ea386b1'
AND (
token = 'HRFOy01MyB/qkkcl1XOpmBOQ4/HzQdImyR1guyzH+1I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)