UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'biy9heCVwjx1RVPelVkxAeWuKSoJbvVXTDYs39OzJus='
WHERE
key_id = '1ab5a48d5153520cbd91cb10f1606e4686c5191d76c60c5d671ff593ed19061b'
AND (
token = 'biy9heCVwjx1RVPelVkxAeWuKSoJbvVXTDYs39OzJus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)