UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fhnL+T6UFEmh92G9O9wiNeKvLEdscp0wrA83yXfIg0A='
WHERE
key_id = 'c472452f9be62be014a131aa24c5665fd0c5bdd52ab9705d7404b7cb5840a16e'
AND (
token = 'fhnL+T6UFEmh92G9O9wiNeKvLEdscp0wrA83yXfIg0A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)