UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KntIK1my1oYbp5Ric75boVW3C0HBgGod5ONrlLzXdXU='
WHERE
key_id = '804ac5eae342f6554a383b832d6a1d4649bdc07ec022bc3e33ceb01b3aed9989'
AND (
token = 'KntIK1my1oYbp5Ric75boVW3C0HBgGod5ONrlLzXdXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)