UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vN/aVnWpqXoX+JtvM8tMg4u3H+TliFUvDLYq6rhx3G4='
WHERE
key_id = '12ffddfcf7dbe573c2a930dd659abc2d39b8073002a62b898fdb0423a988d2a2'
AND (
token = 'vN/aVnWpqXoX+JtvM8tMg4u3H+TliFUvDLYq6rhx3G4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)