UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ln6lGNBXW9yhOJ1YqzmIZ8cBJl1JNUiqRugh9swzww='
WHERE
key_id = '6ede80f520bb891d465f891eb56da218bfa0f84be99fd41ee22fd9bb306ccd5c'
AND (
token = '9ln6lGNBXW9yhOJ1YqzmIZ8cBJl1JNUiqRugh9swzww='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)