UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nci/66xOL+9mlH5bD1AYA2U1hXVRee/cpvhiX4D2Q7g='
WHERE
key_id = 'efc7702b40abe7e7b4db9e6569dd500f5947931761c58ad21c43828dd5638414'
AND (
token = 'Nci/66xOL+9mlH5bD1AYA2U1hXVRee/cpvhiX4D2Q7g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)