UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1OxVLUwYoCD8tF5QQ4D9nUkW4s4xY3Q7lGojtik68N0='
WHERE
key_id = 'c72aee8cb0a345de34f2d5c17719013c64dbfa4425e022bef3c2764301efe0e3'
AND (
token = '1OxVLUwYoCD8tF5QQ4D9nUkW4s4xY3Q7lGojtik68N0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)