UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CrI6AtpppbYsVW/XZx3+EIe8sAyTp41c337u2mB5MTo='
WHERE
key_id = 'fe3c4874cc28914525c97861da526159b8738b036f6b328d987ea8648281db0d'
AND (
token = 'CrI6AtpppbYsVW/XZx3+EIe8sAyTp41c337u2mB5MTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)