UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NYkNw4iHgQh3hI6i5u04LdZqGVe90vf4LYNyz/MQBiM='
WHERE
key_id = '97d6ab8ffedde484602dd70d94a3bd18b6a315247b35bc7c72ec7902d904c0ca'
AND (
token = 'NYkNw4iHgQh3hI6i5u04LdZqGVe90vf4LYNyz/MQBiM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)