UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5p4MlK8zD9T3XyWYrQ0ZFkHDsJWYdVoz6izOJwohqdk='
WHERE
key_id = '6b46148e11ff6bf1baa69f44c5f9a452f60130bc0956553170e1e00632afe1b3'
AND (
token = '5p4MlK8zD9T3XyWYrQ0ZFkHDsJWYdVoz6izOJwohqdk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)