UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mRJopYnr6rQ+VvjbzKlIY9MIsZR+QyExHnp/gX4Ua1I='
WHERE
key_id = 'd19c033554e9855778102dbb6beea850b2bc4e1bdbced16af23748ae9714021d'
AND (
token = 'mRJopYnr6rQ+VvjbzKlIY9MIsZR+QyExHnp/gX4Ua1I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)