UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVLSHdVKEV7xhYaylVN3xuDBoDibZs4pjiD4DhXNZ64='
WHERE
key_id = '8e7cf2caf55fce879d72bdcf8a6acd6ddd8a88c4eb8c7b173377894d5e3319bb'
AND (
token = 'ZVLSHdVKEV7xhYaylVN3xuDBoDibZs4pjiD4DhXNZ64='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)