UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G3PH8JsbnUOToZdg+Fl7tq4s1+/30rtJePyzo78y6gw='
WHERE
key_id = '899a111cbf648a3c06ac37ef33ebfc3674188b9bb8cc634b6fe32dcc73dd1812'
AND (
token = 'G3PH8JsbnUOToZdg+Fl7tq4s1+/30rtJePyzo78y6gw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)