UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XcnWgMm7f7ScctEj35qWMe3NWWrSag3txLjicyj3ffw='
WHERE
key_id = 'e14657c950171b32c86c1431c1c28d1577d6805b6642aed5b508d040ea260d01'
AND (
token = 'XcnWgMm7f7ScctEj35qWMe3NWWrSag3txLjicyj3ffw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)